SET character_set_client = gb2312; 
SET character_set_connection = gb2312; 
SET character_set_database = gb2312; 
SET character_set_results = gb2312; 
SET character_set_server = gb2312;
CREATE TABLE `yinshidacard_info` (
   `id` int(11) not null auto_increment,
   `dacarddates` date,`yinshicanci` varchar(50),`foodnamec` varchar(50),`sheruliang` varchar(50),`memoinfos` varchar(500),`foodcardluli` varchar(50),`dacardby` varchar(50),`status` varchar(10) DEFAULT '是',
   `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
   PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312 AUTO_INCREMENT=2;

insert into yinshidacard_info(dacarddates,yinshicanci,foodnamec,sheruliang,memoinfos,foodcardluli,dacardby) values('2025-2-16','早餐','D食物','A摄入量','A备注信息','A食物卡路里','027');insert into yinshidacard_info(dacarddates,yinshicanci,foodnamec,sheruliang,memoinfos,foodcardluli,dacardby) values('2025-3-7','其他','J食物','B摄入量','B备注信息','B食物卡路里','013');insert into yinshidacard_info(dacarddates,yinshicanci,foodnamec,sheruliang,memoinfos,foodcardluli,dacardby) values('2025-2-19','夜宵','G食物','C摄入量','C备注信息','C食物卡路里','028');insert into yinshidacard_info(dacarddates,yinshicanci,foodnamec,sheruliang,memoinfos,foodcardluli,dacardby) values('2025-3-12','夜宵','Y食物','D摄入量','D备注信息','D食物卡路里','026');insert into yinshidacard_info(dacarddates,yinshicanci,foodnamec,sheruliang,memoinfos,foodcardluli,dacardby) values('2025-3-7','早餐','K食物','E摄入量','E备注信息','E食物卡路里','007');insert into yinshidacard_info(dacarddates,yinshicanci,foodnamec,sheruliang,memoinfos,foodcardluli,dacardby) values('2025-3-12','午餐','M食物','F摄入量','F备注信息','F食物卡路里','029');insert into yinshidacard_info(dacarddates,yinshicanci,foodnamec,sheruliang,memoinfos,foodcardluli,dacardby) values('2025-2-16','晚餐','S食物','G摄入量','G备注信息','G食物卡路里','018');insert into yinshidacard_info(dacarddates,yinshicanci,foodnamec,sheruliang,memoinfos,foodcardluli,dacardby) values('2025-1-21','午餐','L食物','H摄入量','H备注信息','H食物卡路里','020');






